<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<!--
  Copyright © 2023 Petr Panteleyev <petr@panteleyev.org>
  SPDX-License-Identifier: BSD-2-Clause
  -->
<!--suppress SqlNoDataSourceInspection -->
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
                   xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
                   xmlns:pro="http://www.liquibase.org/xml/ns/pro"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-4.1.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.1.xsd"
                   logicalFilePath="v23.8.2/changelog.xml">

    <changeSet id="v23.8.2-currency" author="petr-panteleyev@yandex.ru">
        <sql>
            ALTER TABLE currency
                ADD COLUMN type VARCHAR NOT NULL DEFAULT 'CURRENCY',
                ADD COLUMN isin VARCHAR NOT NULL DEFAULT '',
                ADD COLUMN registry VARCHAR NOT NULL DEFAULT ''
        </sql>
        <rollback>
            <sql>
                ALTER TABLE currency
                    DROP COLUMN type,
                    DROP COLUMN isin,
                    DROP COLUMN registry
            </sql>
        </rollback>
    </changeSet>
</databaseChangeLog>
